EquityDefinitionV3
THE EQUITY LINE - one row per equity-family ticker: a share class, ETF, ADR, depositary receipt or fund, the satellite that TickerKeyDefinition's symbolType selects. The facts of the line itself and of the chains that settle into it. A cash index's line is IndexDefinitionV3's (9109). ONE LINE PER CURRENCY, and each line heads its own complex: each quotes, prices and holds positions in its own currency, and the lines of one ISIN all carry that ISIN. A European line (tickerSrc SCE) is keyed [base]^[ccy] (SAP^EUR; NOKIA^EUR and NOKIA^SEK for a share that trades in two currencies), where [ccy] is the money currency, so a line quoted in pence is ^GBP; its bare base (SAP) is no key. A line from any other source keeps its plain ticker (NMS AAPL). Every option root and futures product whose exercise delivers these shares settles into the line in its own currency. A venue's book is a VenueListingDefinitionV3 (9139) row on the line in its currency naming its quoteKey, never a second line and never a row here. The line's parent in the tree is its obligor (obligorKey); nothing sits between them. ABSENCE IS THE ASSERTION. A key that is not an equity line has no row. A futures product head has none: every futures product is its own complex and reads CCodeDefinitionV3 (9115). A venue's market-data key (TickerKeyDefinitionV3 symbolType VenueListing) has none.
METADATA
| Attribute | Value |
|---|---|
| Topic | 9100-product-def-core |
| MLink Token | EquityDefinition |
| Product | SRReference |
| accessType | SELECT |
| MLink Endpoint | MLink-Live |
Table Definition
| Field | Type | Key | Default Value | Comment |
|---|---|---|---|---|
| ticker_at | enum - AssetType | PRI | 'None' | AT EQT equityfamily symbolType the spine row must exist |
| ticker_ts | enum - TickerSrc | PRI | 'None' | AT EQT equityfamily symbolType the spine row must exist |
| ticker_tk | VARCHAR(12) | PRI | '' | AT EQT equityfamily symbolType the spine row must exist |
| sharesOutstanding | BIGINT | 0 | thousands | |
| roundlot | INT | 0 | NOT always 100 outside the US Tokyo trades in 100s some HK lines in 500s2000s | |
| issueClass | VARCHAR(1) | '' | blank when the line has no class suffix | |
| parValue | FLOAT | 0 | ||
| parValueCurrency | VARCHAR(3) | '' | matches 43754380 which already carry string3 no conversion | |
| obligorKey_at | enum - AssetType | 'None' | AT ENT | |
| obligorKey_ts | enum - TickerSrc | 'None' | AT ENT | |
| obligorKey_tk | VARCHAR(12) | '' | AT ENT | |
| primaryMic | VARCHAR(4) | '' | ISO 10383 the home listing venue | |
| tapeCode | enum - TapeCode | 'None' | SIP tape A B C | |
| stkPriceInc | enum - StkPriceInc | 'None' | ||
| otcPrimaryMarket | enum - OTCPrimaryMarket | 'None' | ||
| otcTier | enum - OTCTier | 'None' | ||
| otcReportingStatus | VARCHAR(1) | '' | ||
| otcDisclosureStatus | INT | 0 | ||
| otcFlags | INT | 0 | ||
| isHftTaxLiable | enum - YesNo | 'None' | ||
| hftTaxTriggerTime | DOUBLE | 0 | seconds order activity must be withheld Italian default 5 | |
| tradingPeriod | enum - TradingPeriod | 'None' | ||
| v3Source | enum - V3Source | 'None' | ||
| timestamp | DATETIME(6) | '1900-01-01 00:00:00.000000' | ||
| scheduleGroup | VARCHAR(6) | '' | ScheduleDefinitionV3 9057 empty | |
| settlementDays | TINYINT UNSIGNED | 0 | Tn of the current regime 0 means T0 never unknown | |
| borrowDayCount | enum - DayCount | 'None' | stockloan accrual basis of the name Act360 US Act365 sterling | |
| flexTypeFlag | VARCHAR(255) | 'None' | FLEX series types that may be MINTED on this underlier None no FLEX A FLEX order mints a root before any root exists | |
| priceFormat | enum - PriceFormat | 'None' | how this line quotes | |
| minTickSize | DOUBLE | 0 | the lines smallest price increment | |
| hasOptions | enum - YesNo | 'None' | HINT subscription filter only may lag the collection | |
| linkedPrimaryFuture_at | enum - AssetType | 'None' | the future whose expiry bars drive this lines option chains | |
| linkedPrimaryFuture_ts | enum - TickerSrc | 'None' | the future whose expiry bars drive this lines option chains | |
| linkedPrimaryFuture_tk | VARCHAR(12) | '' | the future whose expiry bars drive this lines option chains | |
| defaultRoot_at | enum - AssetType | 'None' | the root the tools open by default when a line has several an index lines is on 9109 | |
| defaultRoot_ts | enum - TickerSrc | 'None' | the root the tools open by default when a line has several an index lines is on 9109 | |
| defaultRoot_tk | VARCHAR(12) | '' | the root the tools open by default when a line has several an index lines is on 9109 | |
| pointValue | FLOAT | 0 | 0 reads as 1 | |
| pointCurrency | VARCHAR(3) | '' | empty the spines primaryCurrency |
PRIMARY KEY DEFINITION (Unique)
| Field | Sequence |
|---|---|
| ticker_tk | 1 |
| ticker_at | 2 |
| ticker_ts | 3 |
SELECT TABLE EXAMPLE QUERY
SELECT *
FROM `SRReference`.`MsgEquityDefinitionV3`
WHERE
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE','CRDT','GCR','SWAP','ENT','MBS','SET','LOAN') */
`ticker_at` = 'NONE'
AND
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX','CRCY','CMDY','DTI','SOVN','SR_US','SR_EU','SR_AP','SR_UK','USD','EUR','GBP','CHF','JPY','CAD','AUD','HKD','KRW','INR','SGD','TWD','CNY','CNH','BRL','MXN','ZAR','SEK','NOK','DKK','PLN','ILS','TRY','NZD','THB','MYR','IDR','PHP','CZK','HUF','SAR','AED','CLP','COP') */
`ticker_ts` = 'NONE'
AND
/* Replace with a VARCHAR(12) */
`ticker_tk` = 'Example_ticker_tk';
Doc Columns Query
SELECT * FROM SRReference.doccolumns WHERE TABLE_NAME='EquityDefinitionV3' ORDER BY ordinal_position ASC;